[dbo].[BAEOrderCategoryLoadParent]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderCategoryLoadParent

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@OrderCategoryID	int	4

SQL Script

create procedure [dbo].[BAEOrderCategoryLoadParent] @OrderCategoryID as
int
AS
    SELECT * FROM OrderCategory WHERE OrderCategoryID =
        (SELECT OrderCategoryParentID FROM OrderCategory AS oc JOIN OrderCategoryParentLookup AS ocpl ON
        oc.OrderCategoryID = ocpl.OrderCategoryID WHERE oc.OrderCategoryID = @OrderCategoryID);

GO

Uses

[dbo].[OrderCategory]
[dbo].[OrderCategoryParentLookup]
dbo